Nursing Data Post-processing File 01

Dataset statistics

Number of variables	31
Number of observations	9082
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	200.0 B

Variable types

BOOL	15
NUM	11
CAT	5

Reproduction

Analysis started	2021-04-21 15:32:21.363310
Analysis finished	2021-04-21 15:33:43.867825
Duration	1 minute and 22.5 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`Provider Name` has a high cardinality: 212 distinct values	High cardinality
`Provider City` has a high cardinality: 100 distinct values	High cardinality
`Total Number of Occupied Beds` is highly correlated with `Number of All Beds`	High correlation
`Number of All Beds` is highly correlated with `Total Number of Occupied Beds`	High correlation
`Week Ending` is uniformly distributed	Uniform
`Provider Name` is uniformly distributed	Uniform
`Residents Total Admissions COVID-19` has 1980 (21.8%) zeros	Zeros
`Residents Total Confirmed COVID-19` has 1362 (15.0%) zeros	Zeros
`Residents Total Suspected COVID-19` has 2621 (28.9%) zeros	Zeros
`Residents Weekly All Deaths` has 5784 (63.7%) zeros	Zeros
`Residents Total All Deaths` has 361 (4.0%) zeros	Zeros
`Residents Total COVID-19 Deaths` has 2087 (23.0%) zeros	Zeros
`Staff Total Confirmed COVID-19` has 827 (9.1%) zeros	Zeros
`Staff Weekly Suspected COVID-19` has 8549 (94.1%) zeros	Zeros
`Staff Total Suspected COVID-19` has 2797 (30.8%) zeros	Zeros

Week Ending
Categorical

UNIFORM

Distinct count	43
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

2020-06-14T00:00:00	212
2020-09-27T00:00:00	212
2020-09-20T00:00:00	212
2020-08-23T00:00:00	212
2020-07-19T00:00:00	212
Other values (38)	8022

Common Values
Length

Value	Count	Frequency (%)
2020-06-14T00:00:00	212	2.3%
2020-09-27T00:00:00	212	2.3%
2020-09-20T00:00:00	212	2.3%
2020-08-23T00:00:00	212	2.3%
2020-07-19T00:00:00	212	2.3%
2020-06-28T00:00:00	212	2.3%
2020-05-31T00:00:00	212	2.3%
2020-05-24T00:00:00	212	2.3%
2020-08-09T00:00:00	212	2.3%
2020-09-13T00:00:00	212	2.3%
Other values (33)	6962	76.7%

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Provider Name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	212
Unique (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

ORANGE HEALTH CARE CENTER	43
GROVE MANOR NURSING HOME, INC	43
APPLE REHAB ROCKY HILL	43
CASSENA CARE AT STAMFORD	43
ABBOTT TERR HEALTH CTR	43
Other values (207)	8867

Common Values
Length

Value	Count	Frequency (%)
ORANGE HEALTH CARE CENTER	43	0.5%
GROVE MANOR NURSING HOME, INC	43	0.5%
APPLE REHAB ROCKY HILL	43	0.5%
CASSENA CARE AT STAMFORD	43	0.5%
ABBOTT TERR HEALTH CTR	43	0.5%
NORTHBRIDGE HEALTH CARE CENTER	43	0.5%
HAMDEN REHABILITATION & HEALTH CARE CENTER	43	0.5%
VILLA MARIA NURSING & REHAB COMMUNITY, INC	43	0.5%
AUTUMN LAKE HEALTHCARE AT NEW BRITAIN	43	0.5%
ST JOSEPHS LIVING CENTER	43	0.5%
Other values (202)	8652	95.3%

Length

Max length	50
Median length	26
Mean length	27.03501431
Min length	7

Provider City
Categorical

HIGH CARDINALITY

Distinct count	100
Unique (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

WATERBURY	334
MERIDEN	301
STAMFORD	215
NEW HAVEN	215
NEW BRITAIN	215
Other values (95)	7802

Common Values
Length

Value	Count	Frequency (%)
WATERBURY	334	3.7%
MERIDEN	301	3.3%
STAMFORD	215	2.4%
NEW HAVEN	215	2.4%
NEW BRITAIN	215	2.4%
WEST HARTFORD	215	2.4%
DANBURY	215	2.4%
BRISTOL	172	1.9%
MIDDLETOWN	172	1.9%
HARTFORD	172	1.9%
Other values (90)	6856	75.5%

Length

Max length	16
Median length	9
Mean length	8.759083902
Min length	4

Residents Total Admissions COVID-19
Real number (ℝ_≥0)

ZEROS

Distinct count	196
Unique (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15.213279013433164
Minimum	0
Maximum	535
Zeros	1980
Zeros (%)	21.8%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	17
95-th percentile	56
Maximum	535
Range	535
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	31.65158627
Coefficient of variation (CV)	2.080523617
Kurtosis	74.6270188
Mean	15.21327901
Median Absolute Deviation (MAD)	6
Skewness	6.898305587
Sum	138167
Variance	1001.822914

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1980	21.8%
1	902	9.9%
2	491	5.4%
4	461	5.1%
7	373	4.1%
10	357	3.9%
6	332	3.7%
5	310	3.4%
3	296	3.3%
8	271	3.0%
Other values (186)	3309	36.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1980	21.8%
1	902	9.9%
2	491	5.4%
3	296	3.3%
4	461	5.1%

Value	Count	Frequency (%)
535	1	< 0.1%
528	1	< 0.1%
521	1	< 0.1%
513	1	< 0.1%
494	1	< 0.1%

Residents Total Confirmed COVID-19
Real number (ℝ_≥0)

ZEROS

Distinct count	159
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	37.77659105923805
Minimum	0
Maximum	171
Zeros	1362
Zeros (%)	15.0%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	28
Q3	63
95-th percentile	102
Maximum	171
Range	171
Interquartile range (IQR)	59

Descriptive statistics

Standard deviation	35.79671296
Coefficient of variation (CV)	0.9475898156
Kurtosis	0.06923640367
Mean	37.77659106
Median Absolute Deviation (MAD)	27
Skewness	0.8418299912
Sum	343087
Variance	1281.404658

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1362	15.0%
1	399	4.4%
2	235	2.6%
3	197	2.2%
5	190	2.1%
18	165	1.8%
28	163	1.8%
20	161	1.8%
23	144	1.6%
17	132	1.5%
Other values (149)	5934	65.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1362	15.0%
1	399	4.4%
2	235	2.6%
3	197	2.2%
4	107	1.2%

Value	Count	Frequency (%)
171	2	< 0.1%
170	15	0.2%
169	1	< 0.1%
168	1	< 0.1%
167	1	< 0.1%

Residents Total Suspected COVID-19
Real number (ℝ_≥0)

ZEROS

Distinct count	107
Unique (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15.439440651838803
Minimum	0
Maximum	293
Zeros	2621
Zeros (%)	28.9%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	18
95-th percentile	69
Maximum	293
Range	293
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	32.80970818
Coefficient of variation (CV)	2.125058085
Kurtosis	30.82677992
Mean	15.43944065
Median Absolute Deviation (MAD)	3
Skewness	4.812728346
Sum	140221
Variance	1076.476951

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2621	28.9%
1	1071	11.8%
2	598	6.6%
3	517	5.7%
4	287	3.2%
6	272	3.0%
5	213	2.3%
20	200	2.2%
7	182	2.0%
21	178	2.0%
Other values (97)	2943	32.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2621	28.9%
1	1071	11.8%
2	598	6.6%
3	517	5.7%
4	287	3.2%

Value	Count	Frequency (%)
293	25	0.3%
292	12	0.1%
288	1	< 0.1%
286	1	< 0.1%
279	1	< 0.1%

Residents Weekly All Deaths
Real number (ℝ_≥0)

ZEROS

Distinct count	44
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.8313146883946267
Minimum	0
Maximum	71
Zeros	5784
Zeros (%)	63.7%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	71
Range	71
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.777344239
Coefficient of variation (CV)	3.34090601
Kurtosis	175.2695731
Mean	0.8313146884
Median Absolute Deviation (MAD)	0
Skewness	11.04748687
Sum	7550
Variance	7.71364102

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5784	63.7%
1	2033	22.4%
2	724	8.0%
3	223	2.5%
4	104	1.1%
5	34	0.4%
6	24	0.3%
7	24	0.3%
8	14	0.2%
10	13	0.1%
Other values (34)	105	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5784	63.7%
1	2033	22.4%
2	724	8.0%
3	223	2.5%
4	104	1.1%

Value	Count	Frequency (%)
71	1	< 0.1%
66	1	< 0.1%
56	1	< 0.1%
52	1	< 0.1%
51	1	< 0.1%

Residents Total All Deaths
Real number (ℝ_≥0)

ZEROS

Distinct count	138
Unique (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.088526756221096
Minimum	0
Maximum	196
Zeros	361
Zeros (%)	4.0%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	19
Q3	32
95-th percentile	61
Maximum	196
Range	196
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	20.54581936
Coefficient of variation (CV)	0.8898713883
Kurtosis	7.830760268
Mean	23.08852676
Median Absolute Deviation (MAD)	11
Skewness	2.063673226
Sum	209690
Variance	422.1306931

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	361	4.0%
1	343	3.8%
19	299	3.3%
3	294	3.2%
15	254	2.8%
10	248	2.7%
2	238	2.6%
21	237	2.6%
9	230	2.5%
11	229	2.5%
Other values (128)	6349	69.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	361	4.0%
1	343	3.8%
2	238	2.6%
3	294	3.2%
4	220	2.4%

Value	Count	Frequency (%)
196	1	< 0.1%
192	1	< 0.1%
191	2	< 0.1%
186	1	< 0.1%
185	1	< 0.1%

Residents Total COVID-19 Deaths
Real number (ℝ_≥0)

ZEROS

Distinct count	65
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10.087976216692358
Minimum	0
Maximum	84
Zeros	2087
Zeros (%)	23.0%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	16
95-th percentile	29
Maximum	84
Range	84
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.92314658
Coefficient of variation (CV)	1.082788693
Kurtosis	5.562729679
Mean	10.08797622
Median Absolute Deviation (MAD)	7
Skewness	1.81117525
Sum	91619
Variance	119.3151313

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2087	23.0%
1	560	6.2%
7	498	5.5%
2	365	4.0%
5	359	4.0%
6	349	3.8%
13	342	3.8%
4	328	3.6%
9	326	3.6%
8	299	3.3%
Other values (55)	3569	39.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2087	23.0%
1	560	6.2%
2	365	4.0%
3	172	1.9%
4	328	3.6%

Value	Count	Frequency (%)
84	5	0.1%
83	3	< 0.1%
81	3	< 0.1%
78	2	< 0.1%
76	1	< 0.1%

Number of All Beds
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	92
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	116.31424796300374
Minimum	0
Maximum	360
Zeros	3
Zeros (%)	< 0.1%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	45
Q1	76
median	120
Q3	137
95-th percentile	217
Maximum	360
Range	360
Interquartile range (IQR)	61

Descriptive statistics

Standard deviation	55.49257174
Coefficient of variation (CV)	0.4770917812
Kurtosis	4.211328111
Mean	116.314248
Median Absolute Deviation (MAD)	30
Skewness	1.533746068
Sum	1056366
Variance	3079.425519

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
120	1328	14.6%
60	798	8.8%
90	588	6.5%
150	487	5.4%
130	405	4.5%
75	258	2.8%
128	215	2.4%
160	215	2.4%
180	172	1.9%
126	172	1.9%
Other values (82)	4444	48.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
23	43	0.5%
25	43	0.5%
30	86	0.9%
35	86	0.9%

Value	Count	Frequency (%)
360	43	0.5%
357	43	0.5%
345	43	0.5%
294	43	0.5%
282	43	0.5%

Total Number of Occupied Beds
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	277
Unique (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	85.05450341334507
Minimum	0
Maximum	901
Zeros	34
Zeros (%)	0.4%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	29
Q1	56
median	81
Q3	104
95-th percentile	159
Maximum	901
Range	901
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	42.85129212
Coefficient of variation (CV)	0.5038097973
Kurtosis	18.40884244
Mean	85.05450341
Median Absolute Deviation (MAD)	24
Skewness	2.139015977
Sum	772465
Variance	1836.233237

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
81	184	2.0%
77	136	1.5%
78	135	1.5%
82	131	1.4%
83	131	1.4%
80	125	1.4%
84	124	1.4%
79	124	1.4%
75	120	1.3%
85	117	1.3%
Other values (267)	7755	85.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	0.4%
1	4	< 0.1%
2	1	< 0.1%
4	1	< 0.1%
5	2	< 0.1%

Value	Count	Frequency (%)
901	1	< 0.1%
323	1	< 0.1%
317	1	< 0.1%
314	2	< 0.1%
313	1	< 0.1%

Staff Weekly Confirmed COVID-19
Categorical

Distinct count	47
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

0	6708
1	1251
2	456
3	237
4	98
Other values (42)	332

Common Values
Length

Value	Count	Frequency (%)
0	6708	73.9%
1	1251	13.8%
2	456	5.0%
3	237	2.6%
4	98	1.1%
6	55	0.6%
5	51	0.6%
7	36	0.4%
8	31	0.3%
9	19	0.2%
Other values (37)	140	1.5%

Length

Max length	2
Median length	1
Mean length	1.015415107
Min length	1

Staff Total Confirmed COVID-19
Real number (ℝ_≥0)

ZEROS

Distinct count	118
Unique (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.67022682228584
Minimum	0
Maximum	130
Zeros	827
Zeros (%)	9.1%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	15
Q3	31
95-th percentile	60
Maximum	130
Range	130
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	20.46763429
Coefficient of variation (CV)	0.990198824
Kurtosis	3.471336276
Mean	20.67022682
Median Absolute Deviation (MAD)	12
Skewness	1.597035582
Sum	187727
Variance	418.9240534

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	827	9.1%
1	536	5.9%
2	378	4.2%
3	329	3.6%
5	281	3.1%
4	274	3.0%
8	272	3.0%
23	220	2.4%
14	218	2.4%
15	216	2.4%
Other values (108)	5531	60.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	827	9.1%
1	536	5.9%
2	378	4.2%
3	329	3.6%
4	274	3.0%

Value	Count	Frequency (%)
130	5	0.1%
126	1	< 0.1%
123	1	< 0.1%
117	7	0.1%
116	11	0.1%

Staff Weekly Suspected COVID-19
Real number (ℝ_≥0)

ZEROS

Distinct count	36
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2176833296630698
Minimum	0
Maximum	53
Zeros	8549
Zeros (%)	94.1%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	53
Range	53
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.908507433
Coefficient of variation (CV)	8.767356859
Kurtosis	336.3682511
Mean	0.2176833297
Median Absolute Deviation (MAD)	0
Skewness	16.69552629
Sum	1977
Variance	3.642400623

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	8549	94.1%
1	284	3.1%
2	108	1.2%
3	41	0.5%
4	22	0.2%
5	10	0.1%
6	9	0.1%
8	7	0.1%
10	5	0.1%
7	4	< 0.1%
Other values (26)	43	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8549	94.1%
1	284	3.1%
2	108	1.2%
3	41	0.5%
4	22	0.2%

Value	Count	Frequency (%)
53	2	< 0.1%
48	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
39	1	< 0.1%

Staff Total Suspected COVID-19
Real number (ℝ_≥0)

ZEROS

Distinct count	68
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.109997797841885
Minimum	0
Maximum	80
Zeros	2797
Zeros (%)	30.8%
Memory size	35.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	10
95-th percentile	36
Maximum	80
Range	80
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	13.26590612
Coefficient of variation (CV)	1.635747191
Kurtosis	6.024255523
Mean	8.109997798
Median Absolute Deviation (MAD)	2
Skewness	2.412339573
Sum	73655
Variance	175.9842652

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2797	30.8%
1	1051	11.6%
2	879	9.7%
3	632	7.0%
5	330	3.6%
10	271	3.0%
4	268	3.0%
6	211	2.3%
8	205	2.3%
9	201	2.2%
Other values (58)	2237	24.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2797	30.8%
1	1051	11.6%
2	879	9.7%
3	632	7.0%
4	268	3.0%

Value	Count	Frequency (%)
80	17	0.2%
68	17	0.2%
66	19	0.2%
65	1	< 0.1%
63	18	0.2%

Staff Total COVID-19 Deaths
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	35.5 KiB

0	8505
1	534
2	43

Common Values
Length

Value	Count	Frequency (%)
0	8505	93.6%
1	534	5.9%
2	43	0.5%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Shortage of Nursing Staff
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

N	8574
Y	508

Frequency Table

Value	Count	Frequency (%)
N	8574	94.4%
Y	508	5.6%

Shortage of Clinical Staff
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

N	8880
Y	202

Frequency Table

Value	Count	Frequency (%)
N	8880	97.8%
Y	202	2.2%

Shortage of Aides
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

N	8531
Y	551

Frequency Table

Value	Count	Frequency (%)
N	8531	93.9%
Y	551	6.1%

Shortage of Other Staff
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

N	8802
Y	280

Frequency Table

Value	Count	Frequency (%)
N	8802	96.9%
Y	280	3.1%

Any Current Supply of N95 Masks
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	8670
N	412

Frequency Table

Value	Count	Frequency (%)
Y	8670	95.5%
N	412	4.5%

One-Week Supply of N95 Masks
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	7797
N	1285

Frequency Table

Value	Count	Frequency (%)
Y	7797	85.9%
N	1285	14.1%

Any Current Supply of Surgical Masks
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	8681
N	401

Frequency Table

Value	Count	Frequency (%)
Y	8681	95.6%
N	401	4.4%

One-Week Supply of Surgical Masks
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	8618
N	464

Frequency Table

Value	Count	Frequency (%)
Y	8618	94.9%
N	464	5.1%

Any Current Supply of Eye Protection
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	8682
N	400

Frequency Table

Value	Count	Frequency (%)
Y	8682	95.6%
N	400	4.4%

One-Week Supply of Eye Protection
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	8638
N	444

Frequency Table

Value	Count	Frequency (%)
Y	8638	95.1%
N	444	4.9%

One-Week Supply of Gowns
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	8380
N	702

Frequency Table

Value	Count	Frequency (%)
Y	8380	92.3%
N	702	7.7%

Any Current Supply of Hand Sanitizer
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	9025
N	57

Frequency Table

Value	Count	Frequency (%)
Y	9025	99.4%
N	57	0.6%

Three or More Confirmed COVID-19 Cases This Week or Initial Confirmed COVID-19 Case this Week
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

N	8519
Y	563

Frequency Table

Value	Count	Frequency (%)
N	8519	93.8%
Y	563	6.2%

Able to Test or Obtain Resources to Test All Current Residents Within Next 7 Days
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	9060
N	22

Frequency Table

Value	Count	Frequency (%)
Y	9060	99.8%
N	22	0.2%

Able to Test or Obtain Resources to Test All Staff and/or Personnel Within Next 7 Days
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

Y	9047
N	35

Frequency Table

Value	Count	Frequency (%)
Y	9047	99.6%
N	35	0.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	Week Ending	Provider Name	Provider City	Residents Total Admissions COVID-19	Residents Total Confirmed COVID-19	Residents Total Suspected COVID-19	Residents Weekly All Deaths	Residents Total All Deaths	Residents Total COVID-19 Deaths	Number of All Beds	Total Number of Occupied Beds	Staff Weekly Confirmed COVID-19	Staff Total Confirmed COVID-19	Staff Total Suspected COVID-19	Shortage of Nursing Staff	Shortage of Clinical Staff	Shortage of Aides	Shortage of Other Staff	Any Current Supply of N95 Masks	One-Week Supply of N95 Masks	Any Current Supply of Surgical Masks	One-Week Supply of Surgical Masks	Any Current Supply of Eye Protection	One-Week Supply of Eye Protection	One-Week Supply of Gowns	Any Current Supply of Hand Sanitizer	Three or More Confirmed COVID-19 Cases This Week or Initial Confirmed COVID-19 Case this Week	Able to Test or Obtain Resources to Test All Current Residents Within Next 7 Days	Able to Test or Obtain Resources to Test All Staff and/or Personnel Within Next 7 Days
0	2020-05-24T00:00:00	NORTHBRIDGE HEALTH CARE CENTER	BRIDGEPORT	25	0	0	0	0	0	0	0	1	1	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
1	2020-05-24T00:00:00	ORCHARD GROVE SPECIALTY CARE CENTER, LLC	UNCASVILLE	6	28	3	0	19	7	120	81	0	15	2	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
2	2020-07-19T00:00:00	WATROUS NURSING CENTER	MADISON	0	1	1	0	0	0	45	29	0	1	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
3	2020-06-28T00:00:00	APPLE REHAB SHELTON LAKES	SHELTON	1	0	0	1	2	0	106	73	0	0	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
4	2020-09-13T00:00:00	REGALCARE AT GREENWICH	GREENWICH	11	12	0	0	28	14	75	62	0	7	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
5	2020-11-15T00:00:00	WITHERELL, NATHANIEL	GREENWICH	161	30	14	0	16	16	202	152	1	11	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
6	2020-12-27T00:00:00	AVERY NURSING HOME	HARTFORD	25	82	1	1	39	21	199	141	1	92	11	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y
7	2020-08-30T00:00:00	REGALCARE AT GREENWICH	GREENWICH	11	12	0	0	28	14	75	64	0	7	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
8	2020-10-11T00:00:00	GROVE MANOR NURSING HOME, INC	WATERBURY	2	29	0	0	2	1	60	43	1	7	0	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9	2021-01-31T00:00:00	WINDSOR HEALTH AND REHABILITATION CENTER, LLC	WINDSOR	7	8	1	0	34	0	108	88	0	18	0	Y	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y

Last rows

	Week Ending	Provider Name	Provider City	Residents Total Admissions COVID-19	Residents Total Confirmed COVID-19	Residents Total Suspected COVID-19	Residents Weekly All Deaths	Residents Total All Deaths	Residents Total COVID-19 Deaths	Number of All Beds	Total Number of Occupied Beds	Staff Weekly Confirmed COVID-19	Staff Total Confirmed COVID-19	Staff Total Suspected COVID-19	Staff Total COVID-19 Deaths	Shortage of Nursing Staff	Shortage of Clinical Staff	Shortage of Aides	Shortage of Other Staff	Any Current Supply of N95 Masks	One-Week Supply of N95 Masks	Any Current Supply of Surgical Masks	One-Week Supply of Surgical Masks	Any Current Supply of Eye Protection	One-Week Supply of Eye Protection	One-Week Supply of Gowns	Any Current Supply of Hand Sanitizer	Three or More Confirmed COVID-19 Cases This Week or Initial Confirmed COVID-19 Case this Week	Able to Test or Obtain Resources to Test All Current Residents Within Next 7 Days	Able to Test or Obtain Resources to Test All Staff and/or Personnel Within Next 7 Days
9072	2020-08-16T00:00:00	SOUTHINGTON CARE CENTER	SOUTHINGTON	14	59	12	1	15	9	130	97	0	31	9	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9073	2021-01-17T00:00:00	APPLE REHAB COLCHESTER	COLCHESTER	0	45	0	0	4	2	60	37	0	33	0	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9074	2020-07-12T00:00:00	AVON HEALTH CENTER	AVON	5	50	75	0	32	7	120	92	0	12	32	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9075	2020-12-20T00:00:00	TOUCHPOINTS AT BLOOMFIELD	BLOOMFIELD	64	102	2	0	20	15	150	118	0	21	59	1	N	N	N	N	Y	N	Y	Y	Y	Y	Y	Y	N	Y	Y
9076	2020-11-01T00:00:00	WATROUS NURSING CENTER	MADISON	0	1	1	0	0	0	45	27	0	1	0	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9077	2020-08-23T00:00:00	NOTRE DAME CONVALESCENT HOME I	NORWALK	3	22	38	0	17	13	60	45	0	20	13	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9078	2021-01-24T00:00:00	LEDGECREST HEALTH CARE	KENSINGTON	6	26	1	0	15	5	55	48	0	12	0	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9079	2021-01-31T00:00:00	JOHN L. LEVITOW HEALTH CARE CENTER	ROCKY HILL	12	34	0	0	20	7	125	81	2	42	3	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y
9080	2020-12-06T00:00:00	APPLE REHAB SHELTON LAKES	SHELTON	8	21	0	1	10	0	106	79	2	4	0	0	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y
9081	2020-08-23T00:00:00	BETHEL HEALTH CARE CENTER	BETHEL	23	61	66	0	44	16	161	119	0	30	19	1	N	N	N	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Y	Y

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows